Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
PersonPartyID (FK)(PK) | A unique, system assigned identity for a Party. | ID_PRTY_PRS | Identity | integer | |
LanguageID (FK) | A combination of ISO-639-1 and ISO-3661-1 to denote a lanuage as spoken in a particular country. | ID_LGE | Code4External | char(4) | Language(CO_LGE) |
Salutation | Extra words that don't form part of the person's name but are normally printed before the FirstName as a courtesy title. For instance, Mr. Ms., Miss, Dr., Prof. etc. This represents the primary salutation for this Person. | NM_PRS_SLN | Name | varchar(40) | |
FirstName | A person's first name. In western cultures, this is the given name, in other cultures it may be the family name. This represents a person's most current first name. | FN_PRS | Name | varchar(40) | |
FirstNameType | A code denoting what kind of name the FirstName is, possible values include: GivenName, OtherGivenName, FamilyName, Patronymic | TY_NM_FS | Code2 | char(2) | |
MiddleNames | One or more middle names, that are printed between the person's first and last names. This represents a person's most current first name. | MD_PRS | Name | varchar(40) | |
MiddleNameType | A code denoting what kind of name the MiddleName is, possible values include: GivenName, OtherGivenName, FamilyName, Patronymic | TY_NM_MID | Code2 | char(2) | |
LastName | A person's last name. In western cultures, this is the family (or patronymic) name, in other cultures it may be the given name. This represents a person's most current first name. | LN_PRS | Name | varchar(40) | |
LastNameType | A code denoting what kind of name the LastName is, possible values include: GivenName, OtherGivenName, FamilyName, Patronymic | TY_NM_LS | Code2 | char(2) | |
Suffix | Extra words that don't form part of the person's name but are normally printed after the LastName to help identify the person. Example values include, Sr, Jr, III This represents a person's primary Suffix. | NM_PRS_SFX | Name | varchar(40) | |
GenderTypeCode | A code for specifying a persons gender. | TY_GND_PRS | Code2 | char(2) | |
SortingName | A culturally sensitive version of the person's name that is used when producing a sorted list of names. Examples: Jones, W S McGrigor, S F Tryggvi, T | NM_PRS_SR | Name | varchar(40) | |
MailingName | A culturally sensitive version of the person's name that is used when contacting them Examples: Bill Jones, Stuey McGrigor Tryggvi Thordarson | NM_PRS_ML | Name | varchar(40) | |
OfficialName | A culturally sensitive version of the person's name that is used for all legal documents. Examples: William Stephen Jones Stuart Fergus McGrigor Tryggvi Magnus Thordarson | NM_PRS_OFCL | Name | varchar(40) | |
DateOfBirth | Year, month, and day a Person was born on. | DC_PRS_BRT | DateCalendar | date | |
AnnualIncomeRangeCode (FK) | A customer's annual salary or income. | CD_ANN_INCM_RNGE | Code | varchar(20) | AnnualIncomeRange(LU_ANN_INCM_RNGE) |
MaritalStatusCode (FK) | A code that describes a CUSTOMER's current marital status. For instance, married, single, etc. | CD_MRTL_STS | Code | varchar(20) | MaritalStatus(LU_MRTL_STS) |
RaceCode (FK) | Retailer determined code for indicating a Person's race. | CD_RC | Code | varchar(20) | RaceType(LU_RC_TYP) |
PersonalityTypeCode (FK) | A retailer assigned value that assigns a personality named pattern of behavior to a Person. This plays a role in segmentation Sample Values: COMPULSIVE AUTHORITARIAN GREGARIOUS AMBITIOUS INTROVERTED | CD_PRSNLTY_TYP | Code | varchar(20) | PersonalityType(LU_PRSNLTY_TYP) |
LifestyleTypeCode (FK) | Retailer assigned code that assigns a Person to a named lifestyle pattern. This is used for segmentation purposes. Samples include: LONGHAIRS MODERN FASHIONERS RELIGIOUS_STYLE WORKAHOLIC | CD_LFSTYL_TYP | Code | varchar(20) | LifestyleTypeCode(LU_LFSTYL_TYP) |
PersonalValueTypeCode (FK) | A retailer assigned value that assigns a named pattern of personal values to a Person. This plays a role in segmentation. Sample values include: FAMILY_ORIENTED MATERIALISTIC SPIRITUALISTIC IDEALISTIC | CD_PRSL_VL_TYP | Code | varchar(20) | PersonalValueType(LU_PRSL_VL_TYP) |
OccupationTypeCode (FK) | A retailer assigned code that assigns a Person to an occupation category. This is used in demographic | CD_OCCPTN_TYP | Code | varchar(20) | OccupationType(LU_OCCPTN_TYP) |
ConsumerCreditScore | The credit rating assigned by an independent credit rating service like Fair Isaac, Transunion or Experian in the US | CD_CNS_CR_SCOR | Code | varchar(20) | |
ConsumerCreditRatingServiceName | The name of the ConsumerCreditScore provider. | NM_CNS_CR_RTG_SV | Name | varchar(40) | |
LifeStageCode (FK) | Defines the current family situation of a Person based on characterized composition of family, member ages, and marital status. Examples: Single No Child The primary head of household is single, divorced, separated, or widowed and is younger than 45 years of age. The household supports no dependent children, and the household is not a retired household. Married No Child The primary head of household is married and is younger than 45 years of age. The household supports no dependent children, and the household is not a retired household. Oldest Child 0�11 The household supports at least one dependent child age 11 or younger. It supports no dependent children 12 years of age or older. Oldest Child 12�17 The household supports at least one dependent child between the ages of 12 and 17 years of age. It supports no dependent children age 18 years or older. Oldest Child 18 or Older The household supports at least one dependent child 18 years of age or older. Preretired The primary head of household is 45 years of age or older. The household supports no dependent children, and the household is not a retired household. Younger Retired The primary head of household is 70 years of age or younger. The household supports no dependent children, and the household is a retired household. Older Retired The primary head of household is 70 years of age or older. The household supports no dependent children, and the household is a retired household. | CD_LF_STG | Code | varchar(20) | LifeStageType(LU_LF_STG_TYP) |
EthnicityTypeCode (FK) | Indicates the cultural background of a Person. This is different from race in that it tells about a mixture of language, culture separate from a person's race. Examples include: Hispanic Han Chinese Persian West European East European Retailers should define codes that are relevant to their business. | CD_ETHNC_TYP | Code | varchar(20) | EthnicType(LU_ETHNC_TYP) |
EducationLevelCode (FK) | Designates a level of education completed by a party.. Examples include: ELEMENTARY MIDDLE _SCHOOL HIGH_SCHOOL TWO_YEARS_COLLEGE FOUR_YEAR_COLLEGE TWO_YEAR_GRAD FOUR_YEAR_GRAD POST_GRAD | CD_EDC_LV | Code | varchar(20) | EducationLevel(LU_EDC_LV) |
EmploymentStatusCode (FK) | A code that defines the employment condition of a person. This code is used in segementing customers. Sample values include: STUDENT UNEMPLOYED PART_TIME_UNDEREMPLOYED EMPLOYED SEMI_RETIRED RETIRED | CD_EMPLMT_STS | Code | varchar(20) | EmploymentStatusType(LU_EMPLMT_STS_TYP) |
ValueAttitudeLifestyleTypeCode (FK) | Code used to characterize a consuer/customer value-attitude-lifestyle. Sample VALS values include: INNOVATORS � The class of consumer at the top of the vals framework. They are characterized by High income and high resource individuals for whom independence is very important. They have their own individual taste in things and are motivated in achieving the finer things in life. THINKERS � A well educated professional is an excellent example of Thinkers in the vals framework. These are the people who have high resources and are motivated by their knowledge. These are the rational decision making consumers and are well informed about their surroundings. These consumers are likely to accept any social change because of their knowledge level. BELIEVERS � The subtle difference between thinkers and believers is that thinkers make their own decisions whereas believers are more social in nature and hence also believe other consumers. They are characterized by lower resources and are less likely to accept innovation on their own. They are the best class of word of mouth consumers. ACHIEVERS � The achievers are mainly motivated by � guess what � Achievements. These individuals want to excel at their job as well in their family. Thus they are more likely to purchase a brand which has shown its success over time. The achievers are said to be high resource consumers but at the same time, if any brand is rising, they are more likely to adopt that brand faster. STRIVERS � Low resource consumer group which wants to reach some achievement are known as strivers. These customers do not have the resources to be an achiever. But as they have values similar to an achiever, they fall under the striver category. If a striver can gain the necessary resources such as a high income or social status then he can move on to becoming an achiever. EXPERIENCERS � The group of consumers who have high resources but also need a mode of self expression are known as Experiencers. Mostly characterized by young adults, it consists of people who want to experience being different. This class of consumers is filled up with early adopters who spend heavily on food, clothing and other youthful products and services. MAKERS � These are consumers who also want self expression but they are limited by the number of resources they have. Thus they would be more focused towards building a better family rather than going out and actually spending higher amount of money. Making themselves into better individuals and families becomes a form of self expression for the Makers. SURIVORS � The class of consumers in the Vals framework with the least resources and therefore the least likely to adopt any innovation. As they are not likely to change their course of action regularly, they form into brand loyal customers. An example can include old age pension earners living alone for whom the basic necessities are important and they are least likely to concentrate on anything else. | CD_VL_ATTD_LFSTL | Code | varchar(20) | ValueAttitudeLifestyleType(LU_VL_ATTD_LFSTL) |
DietaryHabitTypeCode (FK) | Code that identifies a particular dietary habit. | CD_DTRY_HBT_TYP | Code | varchar(20) | DietaryHabitType(LU_DTRY_HBT) |
DisabilityImpairmentTypeCode (FK) | Identifies a retailer specified disability or impairment. | CD_DSBLTY_IMPRMNT_TYP | Code | varchar(20) | DisabilityImpairmentType(LU_DSBLTY_IMPRMNT) |
ReligionName (FK) | Name of religion sect within a religion family. 1 Abrahamic religions 1.1 Babism 1.2 Bah�'� Faith 1.3 Christianity 1.3.1 Other groups 1.4 Druze 1.5 Gnosticism 1.6 Islam 1.7 Judaism 1.8 Rastafari movement 1.9 Mandaeans and Sabians 1.10 Samaritanism 1.11 Shabakism 2 Indian religions 2.1 Ayyavazhi 2.2 Bhakti movement 2.3 Buddhism 2.4 Din-i-Ilahi 2.5 Hinduism 2.6 Jainism 2.7 Meivazhi 2.8 Sikhism 3 Iranian religions 3.1 Manichaeism 3.2 Mazdakism 3.3 Mithraism 3.4 Yazd�nism 3.5 Zoroastrianism 4 East Asian religions 4.1 Confucianism 4.2 Shinto 4.3 Taoism 4.4 Other 5 African diasporic religions 6 Indigenous traditional religions 6.1 African 6.2 American 6.3 Eurasian 6.4 Oceania/Pacific 6.4.1 Cargo cults 7 Historical polytheism 7.1 Ancient Near Eastern 7.2 Indo-European 7.3 Hellenistic 8 Mysticism and Occult 8.1 Esotericism and mysticism 8.2 Occult and magic 9 Neopaganism 9.1 Syncretic 9.2 Ethnic 10 New religious movements 10.1 Creativity 10.2 New Thought 10.3 Shinshukyo 11 Left-hand path religions 12 Fictional religions 13 Parody or mock religions 14 Others | NM_RLGN | Code | varchar(20) | ReligionType(LU_RLGN_TYP) |
ReligionFamilyCode (FK) | Abrahamic religions 2 Indian religions 3 Iranian religions 4 East Asian religions 5 African diasporic religions 6 Indigenous traditional religions 7 Historical polytheism 8 Mysticism and Occult 9 Neopaganism 10 New religious movements 11 Left-hand path religions 12 Fictional religions 13 Parody or mock religions 14 Others | CD_RLGN_FMY | Code | varchar(20) | ReligionType(LU_RLGN_TYP) |